Re: [SQL] How match percent sign in SELECT using LIKE? - Mailing list pgsql-sql

From Herouth Maoz
Subject Re: [SQL] How match percent sign in SELECT using LIKE?
Date
Msg-id l03110701b3152aaa9b05@[147.233.159.109]
Whole thread Raw
In response to Re: [SQL] How match percent sign in SELECT using LIKE?  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [SQL] How match percent sign in SELECT using LIKE?
List pgsql-sql
At 00:26 +0200 on 17/03/1999, Bruce Momjian wrote:


> >
> > But I don't have in depth knowledge of the Postgres SQL parser and
> > evaluator so I may be way off base.
>
> That is also an excellent idea.  Just convert their escape to \ inside
> the parser.  Of course, they still have to use \\ to get a \, as in any
> string.  Great idea.

Just a quick note about compliance: It has to work two ways. That is, if
someone imports an SQL script from his previous database (or don't you
think people will be migrating *to* postgres, only *from* it?), it has to
work.

Thus, if someone has a script written to the SQL92 standard, he is allowed
to use a construct like

...WHERE pathname LIKE 'C:\WINDOWS\%'

Without encountering oddities.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma



pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] How match percent sign in SELECT using LIKE?
Next
From: Angelo CONFLITTI
Date:
Subject: Problems with OUTER JOIN - UNION .....